﻿CREATE TABLE [dbo].[BoardSetting] (
  [BoardId] bigint NOT NULL,
  [Password] nvarchar(32) NULL,
  [Icon] nvarchar(255) NULL,
  [PostCredits] varchar(255) NULL,
  [PeplyCredits] varchar(255) NULL,
  [Redirect] varchar(255) NULL,
  [AttachExtensions] varchar(255) NULL,
  [Rules] text NULL,
  [ThreadTypes] text NULL,
  [ViewPermission] text NULL,
  [PostPermission] text NULL,
  [ReplyPermission] text NULL,
  [GetAttachPermission] text NULL,
  [PostAttachPermission] text NULL,
  [Moderators] ntext NULL,
  [ApplyThreadType] bit NULL,
  [PostByThreadType] bit NULL,
  [ViewByThreadType] bit NULL, 
  CONSTRAINT [PK_BoardSetting] PRIMARY KEY CLUSTERED 
(
	[BoardId] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC sp_addextendedproperty N'MS_Description', N'版块配置表', 'SCHEMA', N'dbo', 'TABLE', N'BoardSetting', NULL, NULL
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'版块ID,外键' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'BoardId'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'访问该版块的密码,为空则不用密码' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'Password'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'论坛图标,显示于首页论坛列表等' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'Icon'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'发主题积分策略' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'PostCredits'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'发回复积分策略' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'PeplyCredits'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'指向外部链接的地址' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'Redirect'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'允许在本论坛上传的附件类型,留空为默认' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'AttachExtensions'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'本版规则' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'Rules'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'主题分类' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'ThreadTypes'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'浏览权限设定' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'ViewPermission'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'发主题权限设定' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'PostPermission'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'发回复权限设定' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'ReplyPermission'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'下载附件权限设定' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'GetAttachPermission'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'添加附件权限设定' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'PostAttachPermission'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'版主列表' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'Moderators'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'是否应用主题类型' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'ApplyThreadType'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'发帖必须归类' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'PostByThreadType'
GO
EXEC sys.sp_addextendedproperty N'MS_Description', N'允许按类别浏览' , N'SCHEMA',N'dbo', N'TABLE',N'BoardSetting', N'COLUMN',N'ViewByThreadType'